/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 716

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 55 50 44 41 54 45 20 48 | 45 41 44 45 52 00 63 72 |UPDATE H|EADER.cr|
|00000010| 65 61 74 65 20 74 72 69 | 67 67 65 72 20 74 25 31 |eate tri|gger t%1|
|00000020| 41 63 74 69 6f 6e 5f 25 | 31 35 54 61 62 6c 65 4e |Action_%|15TableN|
|00000030| 61 6d 65 20 61 66 74 65 | 72 20 25 41 63 74 69 6f |ame afte|r %Actio|
|00000040| 6e 20 6f 6e 20 25 54 61 | 62 6c 65 4e 61 6d 65 0d |n on %Ta|bleName.|
|00000050| 0a 20 20 25 49 66 28 25 | 4e 6f 74 28 25 52 65 66 |.  %If(%|Not(%Ref|
|00000060| 43 6c 61 75 73 65 29 29 | 20 7b 52 65 66 65 72 65 |Clause))| {Refere|
|00000070| 6e 63 69 6e 67 20 6f 6c | 64 20 61 73 20 6f 6c 64 |ncing ol|d as old|
|00000080| 20 6e 65 77 20 61 73 20 | 6e 65 77 7d 20 25 45 6c | new as |new} %El|
|00000090| 73 65 20 7b 25 52 65 66 | 43 6c 61 75 73 65 7d 0d |se {%Ref|Clause}.|
|000000a0| 0a 28 65 78 65 63 75 74 | 65 20 69 6e 6c 69 6e 65 |.(execut|e inline|
|000000b0| 20 28 25 41 74 74 73 28 | 22 2c 22 2c 2c 25 4f 6c | (%Atts(|",",,%Ol|
|000000c0| 64 29 2c 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |d),..   |        |
|000000d0| 20 20 20 20 20 20 25 41 | 74 74 73 28 22 2c 22 2c |      %A|tts(",",|
|000000e0| 2c 25 4e 65 77 29 29 0d | 0a 70 72 6f 63 65 64 75 |,%New)).|.procedu|
|000000f0| 72 65 20 70 25 31 41 63 | 74 69 6f 6e 5f 25 31 35 |re p%1Ac|tion_%15|
|00000100| 54 61 62 6c 65 4e 61 6d | 65 20 73 74 61 74 69 63 |TableNam|e static|
|00000110| 0d 0a 50 61 72 61 6d 65 | 74 65 72 73 0d 0a 20 20 |..Parame|ters..  |
|00000120| 25 46 6f 72 45 61 63 68 | 41 74 74 28 29 20 7b 20 |%ForEach|Att() { |
|00000130| 20 25 41 74 74 50 68 79 | 73 44 61 74 61 74 79 70 | %AttPhy|sDatatyp|
|00000140| 65 20 6f 25 31 37 41 74 | 74 46 69 65 6c 64 4e 61 |e o%17At|tFieldNa|
|00000150| 6d 65 0d 0a 20 20 7d 0d | 0a 20 20 25 46 6f 72 45 |me..  }.|.  %ForE|
|00000160| 61 63 68 41 74 74 28 29 | 20 7b 20 20 25 41 74 74 |achAtt()| {  %Att|
|00000170| 50 68 79 73 44 61 74 61 | 74 79 70 65 20 6e 25 31 |PhysData|type n%1|
|00000180| 37 41 74 74 46 69 65 6c | 64 4e 61 6d 65 0d 0a 20 |7AttFiel|dName.. |
|00000190| 20 7d 0d 0a 4c 6f 63 61 | 6c 20 56 61 72 69 61 62 | }..Loca|l Variab|
|000001a0| 6c 65 73 0d 0a 20 20 53 | 71 6c 20 48 61 6e 64 6c |les..  S|ql Handl|
|000001b0| 65 20 68 53 71 6c 0d 0a | 20 20 4e 75 6d 62 65 72 |e hSql..|  Number|
|000001c0| 20 6e 75 6d 72 6f 77 73 | 0d 0a 41 63 74 69 6f 6e | numrows|..Action|
|000001d0| 73 0d 0a 20 20 4f 6e 20 | 50 72 6f 63 65 64 75 72 |s..  On |Procedur|
|000001e0| 65 20 45 78 65 63 75 74 | 65 0d 0a 00 28 27       |e Execut|e...('  |
+--------+-------------------------+-------------------------+--------+--------+